select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Fortune Residence%' or b.enpropertyname like '%Fortune Residence%') order by updateTime Desc, a.dftpic desc
Newly renovated, everything is brand new!! one master bedroom, one guest room. one reading room and one tea house. two balconies. central A/C floor heating.
This is an amazing apt, it was newly renovated, luxury decoration with bright and spacious livingroom and bedrooms, whole house floor heating and wall heating, ...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...
